package cn.psvmc.cxzapi.provider;

public class UserProvider {
    public static String getUserListByNameAndAge(String name, int age) {
        String sql = "SELECT * FROM t_user where 1=1 ";
        if (name != null && !name.isEmpty()) {
            sql += "AND name like concat('%',#{name},'%') ";
        }
        sql += "AND age > #{age} ";
        return sql;
    }
}
